MaterialEventSeriesV3
one record per recurring series of date/time-definite repricing events: bank meetings, gov reports, inventory numbers, auctions, earnings, production policy
METADATA
| Attribute | Value |
|---|---|
| Topic | 9000-product-def-authority |
| MLink Token | ClientLive |
| Product | SRReference |
| accessType | SELECT |
| MLink Endpoint | MLink-Live |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| seriesKey | VARCHAR(24) | PRI | '' | FOMC USCPI WASDE USTAUCTION EARNAAPL LITE eventDefsts seriesKey |
| name | VARCHAR(40) | '' | FOMC decision EIA petroleum status LITE eventDefsts name | |
| category | enum - MaterialEventCategory | 'None' | CentralBank GovtReport InventoryReport Auction Earnings CorpAction ProductionPolicy Expiry MarketHoliday Symbology | |
| sourceName | VARCHAR(40) | '' | Federal Reserve BLS USDA US Treasury the company LITE eventDefsts source | |
| sourceObligorKey_at | enum - AssetType | 'None' | AT ENT when the source is a keyed entity empty otherwise | |
| sourceObligorKey_ts | enum - TickerSrc | 'None' | AT ENT when the source is a keyed entity empty otherwise | |
| sourceObligorKey_tk | VARCHAR(12) | '' | AT ENT when the source is a keyed entity empty otherwise | |
| isMacro | enum - YesNo | 'None' | FOMC CPI NFP reprices everything LITE eventDefsts scopemacro | |
| subjectTicker_at | enum - AssetType | 'None' | the key the series is ABOUT when it has one empty for report series | |
| subjectTicker_ts | enum - TickerSrc | 'None' | the key the series is ABOUT when it has one empty for report series | |
| subjectTicker_tk | VARCHAR(12) | '' | the key the series is ABOUT when it has one empty for report series | |
| cadenceNote | TINYTEXT | '' | the rule in words 8 meetingsyr weekly Wed 1030 LITE eventDefsts cadence | |
| cadenceRule | VARCHAR(64) | '' | machine recurrence RRULEshaped the forecast projectors input empty authored occurrences only | |
| timeZone | enum - SRTimeZone | 'None' | TimeZoneDefinition the zone occurrence times quote in LITE eventDefsts tzName | |
| statusFlag | enum - TkStatusFlag | 'None' | Active or Delisted A delisted row stays resolvable and is never deleted | |
| pendingDelete | enum - YesNo | 'None' | Yes queued for removal stop resolving against this row | |
| meaningNote | TINYTEXT | '' | freetext note on what this row means | |
| rationaleNote | TINYTEXT | '' | why this row is shaped as it is where that is a house reading rather than a market fact | |
| v3Source | enum - V3Source | 'None' | Bridge projected from a legacy record Loader written natively None reads as Loader | |
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' | when this row was last written |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| seriesKey | 1 |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRReference`.`MsgMaterialEventSeriesV3`
WHERE
/* Replace with a VARCHAR(24) */
`seriesKey` = 'Example_seriesKey';
Doc Columns Query
SELECT * FROM SRReference.doccolumns WHERE TABLE_NAME='MaterialEventSeriesV3' ORDER BY ordinal_position ASC;